Exporting
Data from IN,
GNIARMLS - Rapattoni
Using ‘Custom
Export Setup’ to setup the Export Format
Before
you can export data, you must first setup the Export format. This is a one time action that you will need
to do. The format must be setup exactly
as shown in this section for the application to understand the format.
Once
you’ve logged into the Rapatoni system, use the 
drop down button and select the ‘Custom Export
Setup’ button as you see above. Once you
select the ‘Custom Export Setup’, the ‘Listing Information Export’ screen will
be displayed.
If
you defined any previous export formats they will be shown. To define your new export format, press the
‘Create Export’ button as shown above.
When you press this button, you will see the “Create Listing Information
Export Layout” screen as shown below.
First
place the name “Focus1st” as the “Name” as shown above. Make sure that Excel is the File Format;
select “Yes” for the “Include Field Names” option and select “No” for the
“Include Pictures” option. (Note: The
value of the “Display Order” can be left alone or set to ‘1’). Once you’ve provided the Name and selected
the options above press the 
button.
You will now see the ‘Revise Listing Information Export Layout’ screen
as shown below.
Then
you will need to select fields from the “Available Residential Fields” section
and move them over to the “Selected Fields” section. To pick the fields, select a field from the
left table (shown as “Available Residential Fields” and press the 
key.
You will see the item move to the table on the right.
Do
this for each of the options as shown in the graphic above.
Note: Be sure that
you create the “Selected Fields” with the fields shown below (if you include
additional fields they will be ignored).
·
Address
·
Address
– City/Town
·
Bedrooms
·
Bathrooms
·
Combined
SqFt
·
Design
·
DOM
·
List
Price
·
Listing
Date
·
Listing
Number
·
Selling
Date
·
Selling
Price
·
Square
Footage
·
Status
·
Style
Desc
·
Subdivision
Name
·
Year
Built
Once
you have completed the task above, save the results by pressing the 
button.
You are now ready to do your MLS search and export yoru
results.
GNIAR MLS - Rapattoni
In
selecting data from the Central Coast Regional MLS, be sure to select the
options below:
Make
sure that all the status options are selected and select the starting date
(note the staring date of 01/01/2008 assumes the current year is 2010). This option will make sure that all the data
that is needed to create the appropriate graphs, is collected.
You
should also make your normal selection choice by selecting other options that
you would normally select in doing a CMA.
As mentioned earlier, looking at activity in specific subdivisions is a
good starting point.
Once
you’ve selected the search criteria, you may export the results immediately or
press the 
button to see the results as shown below. To download the results, make sure you select
all the data be checking the 
box, and then select the 
button as shown below.
When
you select the 
button, the “Export Options’ dialog shown
below is displayed. Select the
“Focus1st” option and then push the 
button.
Next
you will see the screen shown below.
Data is being downloaded into a file for you.
When
the download has completed you will see a file link as shown below. Select the link and you will be asked if you
want to save the file.
Once
the download starts, you will be asked if you want to save the file. Select the save option and then choose a file
name and location.
Be sure
to remember where you save your file.
This is the exported file that will be used to create your graphs.
You
will see dialog boxes similar to what you see below.
Once
you have saved your exported file, you are ready to run the application.
When
you run the application you will need to point to the exported data file, so
make sure that you’ve placed the file in an easy to find place.
For
instructions on how to run the application, be sure to see the tutorials
located at http://www.focus1st.com.